﻿
@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>SqlQueryForm</title>
</head>
<body>
    <h2>使用EF中SQL语句进行查询员工数量员工数量：@ViewBag.cnt</h2>
    <h3>查询表单数据</h3>
    <table width="1000" bordr="1" class="myTable">

		<table class="myTable" border="1">
			<tr>
				<th>员工编号：</th>
				<th>部门编号：</th>
				<th>员工姓名：</th>
				<th>员工电话：</th>
				<th>所在地区：</th>
				<th>员工工资：</th>

			</tr>
			@foreach (var item in ViewBag.listView1)
			{


				<tr>
					<td>@item.EmpId</td>
					<td>@item.DeptId</td>
					<td>@item.EmpName</td>
					<td>@item.EmpPhone</td>
					<td>@item.EmpArea</td>
					<td>@item.EmpSalary.ToString("F2")</td>

				</tr>
			}


    </table>

</body>
</html>
